- 01. Lesson Overview
- 02. Relational Databases
- 03. Primary Keys & Foreign Keys
- 04. SQL
- 05. Execution Plan
- 06. Client-Server Model
- 07. Example: Jane's Store
- 08. TCP/IP
- 09. Connections and Sessions in TCP/IP
- 10. Transactions
- 11. Installing Postgres
- 12. Postgres Command Line Applications
- 13. Intro to psql
- 14. Using psql - SQL Commands
- 15. Using psql - Final remarks
- 16. Other Postgres Clients
- 17. DBAPIs and psycopg2
- 18. psycopg2: basic usage
- 19. psycopg2: string composition
- 20. psycopg2: fetching results
- 21. Recap